CREATING SLICER AND KIP CARD 11

Creating Year Slicer 

STEP 1- At the visualization tab select slicer visual. Select date table then select year from date hierarchy

STEP 2 - Change to between by clicking slicer ellipsis

STEP 3 -Click on numeric input, Text size=10, Font=Arial Black, Font color=Custom 2e1039

STEP 4-Turn on the background, make the color custom #bda6c6 and 0%trnasparnsy

STEP 5- Turn Slider header and the visual header OFF. Turn on the shadow 

STEP 6- Go to General X position = 912, y position = 0, width = 192, height = 110

Follow the GIF below to apply the above steps 

Creating and formatting GPM% KPI

STEP7- Copy and paste the slicer visual, Remove the year field from the slicer, change the slicer visual to card visual then drag and drop the gross profit margin field from the sales table

STEP 8- Click Data Label make the color custom #bda6c6, Text Size= 33, Font= DIN and for value decimal place =1

STEP 9- Set Category Off, Word Wrap ON, Turn Title On, type GPM% for the title, make the color = custom #bda6c6, Alignment Center, Text Size=22, Font =Arial Black

Follow the GIF below to apply the above steps 



Creating and formatting YOY% KPI

STEP 10- Copy and paste the KPI visual, Remove the GPM% field then drag and drop the YOY% kpi field from the sales table

STEP 11- Click Data Label then click data label function format by filed value, based on KPI Arrow field

STEP 12- Click title change the title to YOY%

Follow the GIF below to apply the above steps 


power bi slicer